﻿CREATE TABLE [dbo].[AircraftSeats] (
    [AircraftSeatId] INT          IDENTITY (1, 1) NOT NULL,
    [AircraftId]     INT          NOT NULL,
    [SeatTypeCode]   VARCHAR (10) NOT NULL,
    [SeatNo]         VARCHAR (10) NOT NULL,
    [SeatRow]        INT          NOT NULL,
    [SeatColumn]     VARCHAR (2)  NOT NULL,
    [IsWindowSeat]   BIT          NULL,
    [IsAisleSeat]    BIT          NULL,
    [RewardPoint]    INT          NULL
);

